home *** CD-ROM | disk | FTP | other *** search
/ Apple Reference & Presen…tion Library 2 (Reseller) / Apple R&P Lib Reseller v2.0.iso / 3-Demos / Third Party Demos / Information Management / Wingz / SDScript / Script05 (.txt) < prev    next >
Encoding:
Wingz Script  |  1989-06-10  |  10.6 KB  |  355 lines  |  [WZSC/WNGZ]
  1. WNGZWZSC01b1R
  2. Demo05
  3. ManyFunctions
  4. Business Functions:
  5. Business
  6. "BONDPRICE(yld,value,rate,ytm,pmts)
  7. "BONDYTM(price,value,rate,ytm,pmts)
  8. CTERM(int,fv,pv)
  9. DDB(cost,salvage,life,period)
  10. FV(pmt,int,term)
  11. FVL(amount,int,term)
  12. INTEREST(prin,pmt,term)
  13. IRR(guess,range)
  14. LOANTERM(prin,pmt,int)
  15. NPV(int,range)
  16. PMT(prin,int,term)
  17. PRINCIPAL(pmt,int,term)
  18. PV(pmt,int,term)
  19. PVL(amount,int,term)
  20. RATE(fv,pv,term)
  21. SLN(cost,salvage,life)
  22. SYD(cost,salvage,life,period)
  23. TERM(pmt,int,fv)
  24. Time/Date Functions:
  25.     Time/Date
  26. ADATE(datenumber,picture)
  27. ADDDAYS(datenumber,days)
  28. ADDHOURS(datenumber,hours)
  29. ADDMINUTES(datenumber,minutes)
  30. ADDMONTHS(datenumber,months)
  31. ADDSECONDS(datenumber,seconds)
  32. ADDYEARS(datenumber,years)
  33. ATIME(datenumber,picture)
  34. CMONTH(month)
  35. CWEEKDAY(weekday)
  36. DATE(year,month,day)
  37. DATEVALUE(datestring)
  38. DAY(datenumber)
  39. DAYNAME(datenumber)
  40. HOUR(datenumber)
  41. MINUTE(datenumber)
  42. MONTH(datenumber)
  43. MONTHNAME(datenumber)
  44. NOW()
  45. SECOND(datenumber)
  46. TIME(hour,minute,second)
  47. TIMEVALUE(timestring)
  48. YEAR(datenumber)
  49. Logical Functions:
  50. Logical
  51. FALSE()
  52. IF(condition,x,y)
  53. ISBLANK(cell)
  54. ISERR(x)
  55. ISNA(x)
  56. ISNUMBER(x)
  57. ISRANGE(x)
  58. ISSTRING(x)
  59. TRUE()
  60. Statistical Functions
  61. Statistical
  62. AVG(itemlist)
  63. COUNT(itemlist)
  64. MAX(itemlist)
  65. MIN(itemlist)
  66. STD(itemlist)
  67. STDEV(itemlist)
  68. SUM(itemlist)
  69. SUMSQ(itemlist)
  70. VAR(itemlist)
  71. VARIANCE(itemlist)
  72. Database Functions:
  73. Database
  74. DAVG(input,offset,criteria)
  75. DCOUNT(input,offset,criteria)
  76. DMAX(input,offset,criteria)
  77. DMIN(input,offset,criteria)
  78. DSTD(input,offset,criteria)
  79. DSTDEV(input,offset,criteria)
  80. DSUM(input,offset,criteria)
  81. DSUMSQ(input,offset,criteria)
  82. DVAR(input,offset,criteria)
  83.  DVARIANCE(input,offset,criteria)
  84. Text Functions:
  85. CHAR(x)
  86. CODE(text)
  87. COLLATE(text1,text2)
  88. CONTAINS(text,searchtext)
  89. CURRENCY(x)
  90. EXACT(text1,text2)
  91. FIND(searchtext,text,start)
  92. LEFT(text,n)
  93. LENGTH(text)
  94. LOWER(text)
  95. MATCH(text,searchtext,start)
  96. MID(text,start,n)
  97. N(range)
  98. NFORMAT(x,format)
  99. PROPER(text)
  100. REPEAT(text,n)
  101. REPLACE(text,start,n,newtext)
  102. RIGHT(text,n)
  103. S(range)
  104. STR(x)
  105. STRING(x,n)
  106. TRIM(text)
  107. UPPER(text)
  108. VALUE(text)
  109. Spreadsheet Functions:
  110. Spreadsheet
  111. CELL()
  112. CELLTEXT(cell)
  113. CHOOSE(n,itemlist)
  114. COL()
  115. COLOF(range)
  116. COLS(range)
  117. ERR()
  118. HLOOKUP(x,range,row)
  119. INDEX(range,column,row)
  120. INDIRECT(text)
  121. MAKECELL(column,row)
  122. $MAKERANGE(column1,row1,column2,row2)
  123. RANGE(text)
  124. ROW()
  125. ROWOF(range)
  126. ROWS(range)
  127. VLOOKUP(x,range,column)
  128. Numeric Functions:
  129. Numeric
  130. ABS(x)
  131. ACOS(x)
  132. ACOSH(x)
  133. ASIN(x)
  134. ASINH(x)
  135. ATAN(x)
  136. ATAN2(x,y)
  137. ATANH(x)
  138. COS(x)
  139. COSH(x)
  140. DEGREES(radians)
  141. EXP(x)
  142. EXPONENTIAL(x)
  143. FACTORIAL(x)
  144. GOAL(initial,result,formula)
  145. GUESS()
  146. INT(x)
  147. LN(x)
  148. LOG(x)
  149. LOGN(x,logbase)
  150. MOD(x,y)
  151.     NORMAL(x)
  152. RADIANS(degrees)
  153. RAND()
  154. ROUND(x,n)
  155. SIGN(x)
  156. SIN(x)
  157. SINH(x)
  158. SQRT(x)
  159. TAN(x)
  160. TANH(x)
  161. UNIFORM(x)
  162. SDOpen
  163. DoSound
  164. Segwaycall sd:SDOpen("Demo05",1)
  165. call sd:DoSound("ManyFunctions")
  166. wait for (sd:Segway * 1) seconds
  167. hide fields
  168. put "Business Functions:" into b1
  169. call sd:DoSound("Business")
  170. put "BONDPRICE(yld,value,rate,ytm,pmts)" into b3
  171. put "BONDYTM(price,value,rate,ytm,pmts)" into b4
  172. put "CTERM(int,fv,pv)" into b5
  173. put "DDB(cost,salvage,life,period)" into b6
  174. put "FV(pmt,int,term)" into b7
  175. put "FVL(amount,int,term)" into b8
  176. put "INTEREST(prin,pmt,term)" into b9
  177. put "IRR(guess,range)" into b10
  178. put "LOANTERM(prin,pmt,int)" into b11
  179. put "NPV(int,range)" into b12
  180. put "PMT(prin,int,term)" into b13
  181. put "PRINCIPAL(pmt,int,term)" into b14
  182. put "PV(pmt,int,term)" into b15
  183. put "PVL(amount,int,term)" into b16
  184. put "RATE(fv,pv,term)" into b17
  185. put "SLN(cost,salvage,life)" into b18
  186. put "SYD(cost,salvage,life,period)" into b19
  187. put "TERM(pmt,int,fv)" into b20
  188. wait for (sd:Segway * 2) seconds
  189. put " " into b1
  190. put " " into b3..b20
  191. put "Time/Date Functions:" into b1
  192. call sd:DoSound("Time/Date")
  193. put "ADATE(datenumber,picture)" into b3
  194. put "ADDDAYS(datenumber,days)" into b4
  195. put "ADDHOURS(datenumber,hours)" into b5
  196. put "ADDMINUTES(datenumber,minutes)" into b6
  197. put "ADDMONTHS(datenumber,months)" into b7
  198. put "ADDSECONDS(datenumber,seconds)" into b8
  199. put "ADDYEARS(datenumber,years)" into b9
  200. put "ATIME(datenumber,picture)" into b10
  201. put "CMONTH(month)" into b11
  202. put "CWEEKDAY(weekday)" into b12
  203. put "DATE(year,month,day)" into b13
  204. put "DATEVALUE(datestring)" into b14
  205. put "DAY(datenumber)" into b15
  206. put "DAYNAME(datenumber)" into b16
  207. put "HOUR(datenumber)" into b17
  208. put "MINUTE(datenumber)" into b18
  209. put "MONTH(datenumber)" into b19
  210. put "MONTHNAME(datenumber)" into b20
  211. put "NOW()" into c3
  212. put "SECOND(datenumber)" into c4
  213. put "TIME(hour,minute,second)" into c5
  214. put "TIMEVALUE(timestring)" into c6
  215. put "YEAR(datenumber)" into c7
  216. wait for (sd:Segway * 2) seconds
  217. put " " into b1
  218. put " " into b3..c21
  219. put "Logical Functions:" into b1
  220. call sd:DoSound("Logical")
  221. put "FALSE()" into b3
  222. put "IF(condition,x,y)" into b4
  223. put "ISBLANK(cell)" into b5
  224. put "ISERR(x)" into b6
  225. put "ISNA(x)" into b7
  226. put "ISNUMBER(x)" into b8
  227. put "ISRANGE(x)" into b9
  228. put "ISSTRING(x)" into b10
  229. put "TRUE()" into b11
  230. wait for (sd:Segway * 1) seconds
  231. put " " into b1
  232. put " " into b3..c21
  233. put "Statistical Functions" into b1
  234. call sd:DoSound("Statistical")
  235. put "AVG(itemlist)" into b3
  236. put "COUNT(itemlist)" into b4
  237. put "MAX(itemlist)" into b5
  238. put "MIN(itemlist)" into b6
  239. put "STD(itemlist)" into b7
  240. put "STDEV(itemlist)" into b8
  241. put "SUM(itemlist)" into b9
  242. put "SUMSQ(itemlist)" into b10
  243. put "VAR(itemlist)" into b11
  244. put "VARIANCE(itemlist)" into b12
  245. wait for (sd:Segway * 1) seconds
  246. put " " into b1
  247. put " " into b3..c21
  248. put "Database Functions:" into b1
  249. call sd:DoSound("Database")
  250. put "DAVG(input,offset,criteria)" into b3
  251. put "DCOUNT(input,offset,criteria)" into b4
  252. put "DMAX(input,offset,criteria)" into b5
  253. put "DMIN(input,offset,criteria)" into b6
  254. put "DSTD(input,offset,criteria)" into b7
  255. put "DSTDEV(input,offset,criteria)" into b8
  256. put "DSUM(input,offset,criteria)" into b9
  257. put "DSUMSQ(input,offset,criteria)" into b10
  258. put "DVAR(input,offset,criteria)" into b11
  259. put "DVARIANCE(input,offset,criteria)" into b12
  260. wait for (sd:Segway * 1) seconds
  261. put " " into b1
  262. put " " into b3..c21
  263. put "Text Functions:" into b1
  264. call sd:DoSound("Text")
  265. put "CHAR(x)" into b3
  266. put "CODE(text)" into b4
  267. put "COLLATE(text1,text2)" into b5
  268. put "CONTAINS(text,searchtext)" into b6
  269. put "CURRENCY(x)" into b7
  270. put "EXACT(text1,text2)" into b8
  271. put "FIND(searchtext,text,start)" into b9
  272. put "LEFT(text,n)" into b10
  273. put "LENGTH(text)" into b11
  274. put "LOWER(text)" into b12
  275. put "MATCH(text,searchtext,start)" into b13
  276. put "MID(text,start,n)" into b14
  277. put "N(range)" into b15
  278. put "NFORMAT(x,format)" into b16
  279. put "PROPER(text)" into b17
  280. put "REPEAT(text,n)" into b18
  281. put "REPLACE(text,start,n,newtext)" into b19
  282. put "RIGHT(text,n)" into b20
  283. put "S(range)" into c3
  284. put "STR(x)" into c4
  285. put "STRING(x,n)" into c5
  286. put "TRIM(text)" into c6
  287. put "UPPER(text)" into c7
  288. put "VALUE(text)" into c8
  289. wait for (sd:Segway * 2) seconds
  290. put " " into b1
  291. put " " into b3..c21
  292. put "Spreadsheet Functions:" into b1
  293. call sd:DoSound("Spreadsheet")
  294. put "CELL()" into b3
  295. put "CELLTEXT(cell)" into b4
  296. put "CHOOSE(n,itemlist)" into b5
  297. put "COL()" into b6
  298. put "COLOF(range)" into b7
  299. put "COLS(range)" into b8
  300. put "ERR()" into b9
  301. put "HLOOKUP(x,range,row)" into b10
  302. put "INDEX(range,column,row)" into b11
  303. put "INDIRECT(text)" into b12
  304. put "MAKECELL(column,row)" into b13
  305. put "MAKERANGE(column1,row1,column2,row2)" into b14
  306. put "NA()" into b15
  307. put "RANGE(text)" into b16
  308. put "ROW()" into b17
  309. put "ROWOF(range)" into b18
  310. put "ROWS(range)" into b19
  311. put "VLOOKUP(x,range,column)" into b20
  312. wait for (sd:Segway * 1.5) seconds
  313. put " " into b1
  314. put " " into b3..c21
  315. put "Numeric Functions:" into b1
  316. call sd:DoSound("Numeric")
  317. put "ABS(x)" into b3
  318. put "ACOS(x)" into b4
  319. put "ACOSH(x)" into b5
  320. put "ASIN(x)" into b6
  321. put "ASINH(x)" into b7
  322. put "ATAN(x)" into b8
  323. put "ATAN2(x,y)" into b9
  324. put "ATANH(x)" into b10
  325. put "COS(x)" into b11
  326. put "COSH(x)" into b12
  327. put "DEGREES(radians)" into b13
  328. put "E()" into b14
  329. put "EXP(x)" into b15
  330. put "EXPONENTIAL(x)" into b16
  331. put "FACTORIAL(x)" into b17
  332. put "GOAL(initial,result,formula)" into b18
  333. put "GUESS()" into b19
  334. put "INT(x)" into b20
  335. put "LN(x)" into c3
  336. put "LOG(x)" into c4
  337. put "LOGN(x,logbase)" into c5
  338. put "MOD(x,y)" into c6
  339. put "NORMAL(x)" into c7
  340. put "PI()" into c8
  341. put "RADIANS(degrees)" into c9
  342. put "RAND()" into c10
  343. put "ROUND(x,n)" into c11
  344. put "SIGN(x)" into c12
  345. put "SIN(x)" into c13
  346. put "SINH(x)" into c14
  347. put "SQRT(x)" into c15
  348. put "TAN(x)" into c16
  349. put "TANH(x)" into c17
  350. put "UNIFORM(x)" into c18
  351. wait for (sd:Segway * 2) seconds
  352. put " " into b1
  353. put " " into b3..c21
  354. close now
  355.